IF exists (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[SelectTraslado]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
	DROP PROCEDURE [dbo].[SelectTraslado]
GO

CREATE PROCEDURE [dbo].[SelectTraslado]
(
	@trasladoID int
)
AS
BEGIN
	SET NOCOUNT ON

	SELECT
	[trasladoID],
	[loteID],
	[origenAlmacenID],
	[destinoAlmacenID],
	[cantidad],
	[fecha],
	[personalID]
	FROM [Traslado]
	WHERE [trasladoID] = @trasladoID

	SET NOCOUNT OFF
END

GO
